# from openpyxl.utils import get_column_letter,column_index_from_string
#
# # 数字变为字母
# print(get_column_letter(1))
#
# # 字母变为数字
# print(column_index_from_string('A'))


#创建工作表
# from openpyxl import Workbook
#
# wb = Workbook()
# wb.create_sheet('new1')
# wb.create_sheet('new2')
# wb.create_sheet('new3')
#
# wb.save('example.xlsx')

#删除工作表
from openpyxl import load_workbook

wb = load_workbook('example.xlsx')
# # 获取工作表
# sheet = wb.get_sheet_by_name('Sheet')
# # print(sheet)
# # exit()
# # 移除工作表
# wb.remove('Sheet')

del wb['new1']
wb.save('example.xlsx')